﻿using Model;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace BLL.sysmanager
{
    public class PlayServer
    {
        public void AddNewPlayLog(ps_play_log PsData)
        {
            string strSql = $"INSERT INTO ps_play_log (play_id,play_count,remark,Merchant_Id,byuser_Id,Means_payment,play_username,play_name,play_userId) " +
                $"VALUES('{PsData.play_id}',{PsData.play_count},'{PsData.remark}','{PsData.Merchant_Id}','{PsData.byuser_Id}','{PsData.Means_payment}','{PsData.play_username}','{PsData.play_name}',{PsData.play_userId})";
            int rowData = DbHelperSQL.ExecuteSql(strSql);
        }

        public DataSet getAllList()
        {
            DataSet ds = new DataSet();
            string strSql = "SELECT * FROM ps_play_log";
            ds = DbHelperSQL.Query(strSql);
            return ds;
        }
    }
}
